ProspectInquiry

EntityType | Independent
Logical Entity Name | ProspectInquiry
Default Table Name | vw_Prospect
Logical Only | YES
Owner |
Definition |
Note |

ProspectInquiry Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
ProspectInquiryId |  | INTEGER | NO |
PersonId |  | INTEGER | YES |
StudentId |  | INTEGER | YES |
StudentInquiryId |  | INTEGER | YES |
CampusID |  | INTEGER | YES |
LeadDate |  | DATETIME | YES |
OriginalAmRepID |  | INTEGER | YES |
AmRepID |  | INTEGER | YES |
AdProgramGroupID |  | INTEGER | YES |
ProgramID |  | INTEGER | YES |
LeadSrcID |  | INTEGER | YES |
LeadTypeID |  | INTEGER | YES |
LastActivityDate |  | DATETIME | YES |
IsCurrent |  | BIT | YES |
RepTypeID |  | INTEGER | YES |
ZoneID |  | INTEGER | YES |
SchoolStatusId |  | INTEGER | YES |
ShiftId |  | INTEGER | YES |
StartDate |  | DATETIME | YES |
PreviousEducationId |  | INTEGER | YES |
OriginalExpStartDate |  | DATETIME | YES |
BestTimetoContact |  | VARCHAR(10) | YES |
ResponsePhone |  | CHAR(16) | YES |
ResponseTime |  | DATETIME | YES |
ResponseDate |  | DATETIME | YES |
AdmissionsRegionId |  | INTEGER | YES |
AdmissionsRepId |  | INTEGER | YES |

ProspectInquiry Keys

Key Name | Key Type | Keys
PK3188 | PrimaryKey | ProspectInquiryId

ProspectInquiry Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
AdmissionsRegion | Non-Identifying | Zero or One to Zero or More |  |  |  | AdmissionsRegionId | NO
AdmissionsRep | Non-Identifying | Zero or One to Zero or More |  |  |  | AdmissionsRepId | NO
SchoolStatus | Non-Identifying | Zero or One to Zero or More |  |  |  | SchoolStatusId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
AdmissionsRepLeadReassignment | Non-Identifying | One To Zero or More |  |  |  |  | NO
ProspectInquiryComment | Non-Identifying | One To Zero or More |  |  |  |  | NO
ProspectInquiryLeadSource | Non-Identifying | One To Zero or More |  |  |  |  | NO
ProspectInquiryProgram | Non-Identifying | One To Zero or More |  |  |  |  | NO
ProspectInquiryStatusSummary | Non-Identifying | One To Zero or More |  |  |  |  | NO
ProspectInquiryStatusSummaryByAdmissRep | Non-Identifying | One To Zero or More |  |  |  |  | NO
Task | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskArchive | Non-Identifying | Zero or One to Zero or More |  |  |  |  | NO

ProspectInquiry Check Constraints

Check Constraint Name | CheckConstraint

ProspectInquiry Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical ProspectInquiry | NO |  |  |
Physical (Microsoft SQL Server) Does Not Exist | NO |  |  |

ProspectInquiry Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Prospect
Logical | Tasks

ProspectInquiry Data Movement Rules

Name | Type | Rule Text/Value